This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I brought a table of 55 records of data into excel that ended up as a single column of dates, numbers, and text that is one record in 14 rows. I've tried transpose, but it doesn't want to break at 14 columns. Is there any way to do this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Have a look at the file in link below. It contains a working example based on your example data.
Forget about reading a 400-page book. To get started with PQ go to the site mentioned below.
Thank you Riny van Eekelen,
That is what I need. I cannot believe I have not found this tool before. I thought I was reasonably knowledgeable about Excel.
You just don't know what you don't know!
Jack Miller
I don't need the data transformed by Ashish. It is dynamic and I am looking for a technique to transform it every few days.
The instructions are in the 400 page book
"Collect, Combine, and Transform Data using Power Query in Excel".
To make it easier for Ashish, post a link to the raw database source,
a link to your present XLSX file and a PDF of your desired results.
Yes, Herbert, that is what I want. How can I get there? You sent me a PDF and XLSX without guidance on how you got there from a single column. Am I missing the instructions?