Sabtu, 08 Februari 2014

[MS_AccessPros] Excel Columns

 

I have a problem with data in a MS Excel spreadsheet in a column. I need 15 columns converted to rows. On the column I need the header to repeat for every item within that column.

problem:
column abc
row 222
row 333
row 444
row 555
row 1236
row 2bca

solution needed:
col-1/col-2 as headers rows all down below
abc 222
abc 333
abc 444
abc 555
abc 1236
abc 2bca

Any help will be greatly appreciated,
Ty

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
.

__,_._,___

Tidak ada komentar:

Posting Komentar