Hi there,
Can anyone help me to write a macro that can convert rows into columns. I have a excel spreadsheet and in column A is the member number. From B to E will be the rest of the detail. On the second line or row the member number will repeat in column A but in column B to E is different information for the member than in row 1.
I want all the information of the member to be in one line. Some member have only 2 lines whereby other members can have more than that.
Any help will be appreciated.
Thanks
Can anyone help me to write a macro that can convert rows into columns. I have a excel spreadsheet and in column A is the member number. From B to E will be the rest of the detail. On the second line or row the member number will repeat in column A but in column B to E is different information for the member than in row 1.
I want all the information of the member to be in one line. Some member have only 2 lines whereby other members can have more than that.
Any help will be appreciated.
Thanks