swap row and column and delete unnecessary

  • Thread starter Thread starter catherine
  • Start date Start date
C

catherine

I have a worksheet that looks something like this:

xinsert 1
yinsert 2
layer 12
el 760
xinsert 5
yinsert 6
layer 12
el 820

I would like to have only one row with xinsert, yinsert,
layer, el in each cell and the corresponding data in the
rows

Thanks
 
Copy, select a cell not in the range, do edit>paste special and check
transpose, then select it, copy it and put
it where you want, delete the remnants of the old range
 
I have over 800 of these recurring columns. Is there
quicker way of deleting only the ones that contain the
text I am now using as my column headings?
 
Catherine,

If you mean you have 800 repeating "sets" of X rows of
data like this:
ColA Col B
xinsert 1
yinsert 2
layer 12
el 760
AAA 12121
xinsert 5 <== begin "set" #2
yinsert 63
layer 12
el 820
AAA 22
xinsert 55 <== begin "set" #3, etc
yinsert 663
layer 120
el 851
AAA 33333

which you want to turn into:

xinsert yinsert layer el AAA
1 2 12 760 12121
5 63 12 820 22
55 663 120 851 33333

Send me your email address and I'll send you a
spreadsheet with a macro that does just what
you want - it'll transpose any number of
constantly repeating sets.

jlr
 
I tried sending it to (e-mail address removed) and
(e-mail address removed) but it was undeliverable
 
I am looking for the same solution - changing columnar information to
row-formatted information.

(e-mail address removed)

Thank you!!
 
Back
Top