Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Bojkins
Frequent Visitor

How to create a column from single cell

Hello,

 

I need to create a column from a single cell. I have multiple single cells in table and need to convert them in to columns.

Data from this single cell needs to populate all cells in new column.

 

If you can help me, I would be very grateful. Thank you, very much. 

 

Best regards,

 

Bojan

7 REPLIES 7
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi Bojan,

 

The cells are in columns. So your expected result isn't clear. Please share a dummy sample and the desired result.

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Please find attached pictures.

 

Idea is to create new columns from one cell, not using fill down or fill up or deleting rows.

 

First picture is actual state and second is desired. 

 

Capture.JPGCapture1.JPG

Best regards,

 

Bojan

Hey, 

 

as there are single cells distributed across the excel sheet, this becomes very cumbersome. Please provide an Excel workbook with sample data, upload the workbook to onedrive or dropbox and share the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi Tom,

 

Here is link : https://www.dropbox.com/s/35fn5cit43ncgmj/Sample%20data.xlsx?dl=0

 

Best regards,

 

Bojan

Hi Bojan,

 

I'm afraid we can't format that table in one go. Can you provide more details, please?

1. There could be more tables like that. How do they organize?

2. Which cells are fixed?

3. Could there be any changes in position or format of these cells?

You could try VBA or Python to format it.

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TomMartens
Super User
Super User

Hey,

 

please excuse, but I do not understand your requirement.

 

Please consider to provide an Excel file with some sample data with to sheets, the first sheet containd the data you have and the 2nd sheet contains the expected result.

 

Upload the xlsx to onedrive or dropbox and share the link-

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hello Tom,

 

I explained on post below. Please get involved if you can help.

 

Thank you.

 

Best regards,

 

Bojan

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.