Macro for single to multiple cols. Help!
Single col excell spreadsheet
example
(rows) all data in col A
1) john doe
2) nice guy
3) 1010 space street
4) Nasa Florida
5) (data separated by 1 row here)
6) Jane Smith
7) Nice girl
8) 1011 Space st
9) Nasa Florida
10)
etc...........
Wishing to populate each row 1-4 into A-D cols. repeating multiple times into just the 4 cols A-D without spaces between the rows.
example.....
(col A) (B) (C) (D)
1)john doe/nice guy/1010 space street/Nasa Florida
2)Jane Smith/Nice girl/1011 Space st/Nasa Florida
3) etc.....
AND!!!
same macro but populating 5 cols from 5 rows, instead of 4.
Much appreciated for the help...
dfkelly42
|