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!!
Is there a function in excel that can do this? Please tell me I don't have to write a macro.
Thanks!!
