Column to Header

P

Pierre

I have a word documents once saved in excel it has the Header/Titles
(A1:down) on the first column. The information for that header is to the
right of it. How would I go about changing that so that when I'm using mail
merge it displays as the header (A1:across).

Example
A B C
1 | FName | John | Michael
2 | LName | Smith | Williams
3 | Address | 4th Street | 8th Ave
 
S

Stefi

Maybe you are looking for Transposing.
Select range
Copy
Select upper left cell of a destination range
PasteSpecial/check Transpose check button

Regards,
Stefi

„Pierre†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find string from column A in Range("B2:F7") list the header of that column/s 5
OFFSET LOOKUP function in VBA? 9
Display index of column headers in column A 9
Make protected hidden row & column headers appear and rehide based ona cell's value 2
Sum across sheets 1
Returning Column Header based on Row and Value 3
Excel 2013 Merge Data 2
Convert repeating row headers into columns 10

Top