•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to convert multiple rows of data per person into 1 row across columns
Our take
Are you frustrated with managing a large dataset where employee cost centers are scattered across multiple rows? You’re not alone. Transforming this disorganized information into a streamlined format with one row per employee can significantly enhance your data analysis. In this guide, we’ll explore efficient methods to consolidate those rows into a single line per person, complete with columns for Employee Number, Name, and multiple Cost Centers and percentages. Keep reading to discover a straightforward solution that will save you time and improve your productivity.
I have a large data set where employee cost centres are split by rows eg
row 1 - employee 1, name, cost centre, cost centre %
Row 2 - employee 1, name, cost centre, cost centre %
Where each employee can have anywhere from 1 to 5 rows each.
I need to convert it into 1 row per person with columns of Employee Number, Employee Name, Cost Centre 1, Cost Centre 1 %, Cost Centre 2, Cost Centre 2% etc.
Is there an easy way to convert this?
TIA
[link] [comments]
Read on the original site
Open the publisher's page for the full experience