S
Strijder
I have a large number of rows in sheet one with columns A-Q (A1, B1, C1
etc); the first line is a header. In a second sheet, I'm trying t
combine the header and each row and then move them into a singl
column, with a space between the transposed records of each row, ie:
A1&A2
B1&B2
...
Q1&Q2
A1&A3
B1&B3
...
Q1&Q3
A1&A4
B1&B4
...
Q1&Q4
etc.
Unfortunately, my column references keep jumping rows in sheet1 when
fill down:
A1&A2
B1&B2
...
Q1&Q2
A1&A20
B1&B20
...
Q1&Q20
Does anyone have any suggestions on how I can consolidate th
rows&columns from Sheet1 into a single column with a line betwee
records?
Thanks in advance =
etc); the first line is a header. In a second sheet, I'm trying t
combine the header and each row and then move them into a singl
column, with a space between the transposed records of each row, ie:
A1&A2
B1&B2
...
Q1&Q2
A1&A3
B1&B3
...
Q1&Q3
A1&A4
B1&B4
...
Q1&Q4
etc.
Unfortunately, my column references keep jumping rows in sheet1 when
fill down:
A1&A2
B1&B2
...
Q1&Q2
A1&A20
B1&B20
...
Q1&Q20
Does anyone have any suggestions on how I can consolidate th
rows&columns from Sheet1 into a single column with a line betwee
records?
Thanks in advance =