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

comparing two tables 0
mail merging filtered records..! 0
XML From Stored Proc 4
Find string from column A in Range("B2:F7") list the header of that column/s 5
Convert repeating row headers into columns 10
Make protected hidden row & column headers appear and rehide based ona cell's value 2
Display index of column headers in column A 9
Need to convert multiple columns into 1 colum in MS Access table 3

Top