Question description:
This user has given permission to use the problem statement for this
blog.
I'm trying to take a column of data and make it into a table. There is a blank row between every grouping. Is there a command to make this a table based of that empty cell?
Solved by T. B. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/05/2018 - 05:00
Hi
User
04/05/2018 - 05:00
Hello
Excelchat Expert
04/05/2018 - 05:00
Welcome to Got it Pro
Excelchat Expert
04/05/2018 - 05:00
Can you paste your sample data and tell more about your requirement
User
04/05/2018 - 05:01
sure
User
04/05/2018 - 05:01
I have a column of data that I copied from a table and I'm trying to make a table out of, when I pasted it, it formatted as a column with each grouping separated by a blank row
Excelchat Expert
04/05/2018 - 05:02
So what do you want
User
04/05/2018 - 05:02
I need to reformat it so that its a table, with name in the first column, followed by Title, Company, City, State and Country
Excelchat Expert
04/05/2018 - 05:02
How would it look like
Excelchat Expert
04/05/2018 - 05:02
can you show?
User
04/05/2018 - 05:02
Like that
User
04/05/2018 - 05:03
I need a command though to automate this I have over 6000 groupings
Excelchat Expert
04/05/2018 - 05:04
I think it cannot be done through excel formulas
Excelchat Expert
04/05/2018 - 05:04
You might need a macro/vba for that
Excelchat Expert
04/05/2018 - 05:04
unfortunately my expertise is not in vba/macros
User
04/05/2018 - 05:04
damn
User
04/05/2018 - 05:05
could you connect me to someone who has that expertise?
Excelchat Expert
04/05/2018 - 05:05
I think when you end the session and when you put the question again just write vba in your question
Excelchat Expert
04/05/2018 - 05:05
I hope a tutor with vba expertise will pick it up
User
04/05/2018 - 05:06
ahh kk
User
04/05/2018 - 05:06
thanks
Excelchat Expert
04/05/2018 - 05:06
Welcome
Excelchat Expert
04/05/2018 - 05:06
Please do give good rating
Excelchat Expert
04/05/2018 - 05:06
i know i have not been much help to you
Excelchat Expert
04/05/2018 - 05:06
:(
Excelchat Expert
04/05/2018 - 05:06
But still a good rating would help a lot
User
04/05/2018 - 05:08
how do i do that
Excelchat Expert
04/05/2018 - 05:08
When you end the session you get an option to rate
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
