smoskowitz
New Member
- Joined
- Jul 21, 2010
- Messages
- 10
Hello --
I have a spreadsheet of data that currently looks something this.
Column A through E
1 John Smith President John.smith@abcd.com 1111111
2 John Smith President John.smith@abcd.com 2222222
3 Rob Levine VP Rob.Levine@abcd.com 5555555
What I need for this spreadsheet to look like is:
1 John Smith President John.Smith@abcd.com 1111111 2222222
2 Rob Levine VP Rob.Levine@abcd.com 5555555
So in other words; my spreadsheet currently has 5 columns. If a person has responsibility for multiple units(Column E) then the information i repeated. What I need is a single entry per user with all of the the units going across the spreadsheet. There are about 1000 lines to this which I think will be reduced to about 600. I am using Excel 2007.
Thanks,
Seth
I have a spreadsheet of data that currently looks something this.
Column A through E
1 John Smith President John.smith@abcd.com 1111111
2 John Smith President John.smith@abcd.com 2222222
3 Rob Levine VP Rob.Levine@abcd.com 5555555
What I need for this spreadsheet to look like is:
1 John Smith President John.Smith@abcd.com 1111111 2222222
2 Rob Levine VP Rob.Levine@abcd.com 5555555
So in other words; my spreadsheet currently has 5 columns. If a person has responsibility for multiple units(Column E) then the information i repeated. What I need is a single entry per user with all of the the units going across the spreadsheet. There are about 1000 lines to this which I think will be reduced to about 600. I am using Excel 2007.
Thanks,
Seth