ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Please HELP.... 6 Rows and multiple columns (https://www.excelbanter.com/excel-discussion-misc-queries/246916-please-help-6-rows-multiple-columns.html)

lolita

Please HELP.... 6 Rows and multiple columns
 
I need help to place information that is in multiple columns with 6 rows into
a SINGLE column to place in our DATABASE... I know about TRANSPOSE, but I
don't know how to get this into a single column without pasting one at
time........

I'd appreciate help!

It needs to look like this: 090109
100000.00731
15.00
067

[cs3tm]

090109
100000.00356
5.00
067

[cs3tm]

090109
100000.00817
15.00
067


Max

Please HELP.... 6 Rows and multiple columns
 
oops, 2 typos

... in A1:E1 down (ie in 6 cols)

should read:
... in A1:F1 down (ie in 6 cols)


.. copy G2 down

should read:
.. copy G1 down

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---



All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com