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.
The cells are in columns. So your expected result isn't clear. Please share a dummy sample and the desired result.
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.
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.
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.
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-
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.