How to group or categorize data from one sheet to another when categories are unknown until data is pushed to output sheet

jriddle19

New Member
Joined
Jan 24, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello, I have a tool that spits out data to excel in a sheet with column headers and several rows of data. From that data, I'd like to transfer it to another sheet in a prettier format and grouped by a certain column based on the output. For example, I have a category column, for every repeated value in that column, I'd like to add the rows for it under it's same named row in the "formatted" sheet. Attached is an example image. The top portion "Data Output" is what I have for the output. I'd like to reference that information and copy it all to another sheet but in a similar format as the bottom section of the imaged, "Formatted Data".

Is there a function in excel that can do this? Please tell me I don't have to write a macro.

Thanks!!
 

Attachments

  • Excel sample.jpg
    Excel sample.jpg
    157.4 KB · Views: 7

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,176,238
Messages
5,902,090
Members
434,939
Latest member
MrDrock

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top