Column Data to Multiple Rows

April 1, 2013 at 07:30:56
Specs: Windows XP
I have a spreadsheet with a column of multiple data points. What I need to do is take every 360 column entries and put them into a single row. I know how to 'transpose' paste, but due to the amount of data, I need a macro to actually do the work for me. I have no experience with macros, but didn't really figure that this was a very detailed one.

EX.

A-------B----C----D--E--F
0-------6----------6--7--2
180----7----------4--5--1
360----2----------9--8--3
0-------4
180----5
360----1
0-------9
180----8
360----3


See More: Column Data to Multiple Rows

Report •


#1
April 1, 2013 at 08:20:28
Sorry, but I don't understand your example. Is that a "before", an "after" or a "before and after"?

What do you mean by "take every 360 column entries and put them into a single row"?

A posting tip:

Please click on the following line and read the instructions on how to post example data in this forum. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question