This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Try a Transpose first, Key Field your first column, all other fields as Data Fields. Then do the Cross Tab, again with your first column as the only Group Data field, and then "Name" as New Column header and "Value" as "Values.
This question is actually fairly common so I went ahead and created a macro that "totally transposes" the data, all rows to columns and vice versa; with the option to do that shift into column headers. Hopefully you or anyone else might find it handy. (Attached).
EDIT: altered to use user-specified column name for the input column to transpose into column headers.