I have 2 lists Item description 1 , and item description 2 in columns A & B, what i would like is to merge the two lists together to make one list in column C, i have tried several methods but none seem to work, can anyone help? many thanks is advance.
i will attach a sample work sheet.
Enter this formula in C2 and copy down
Formula:
Please Login or Register to view this content.
v A B C 1 Item description 1 Item description 2 all items 2 shirt flowers shirt 3 book lamp flowers 4 light light book 5 dress dress lamp 6 light 7 light 8 dress 9 dress
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
First of all thanks, but it only seems to copy text from column A? again thanks for your help
My mistake, it works perfectly. many thanks Oly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks