Hi, first time poster here...go easy! LOL
I have a spreadsheet and in the asset column i have a list of numbers related to that one line of information. All separated by a comma
[TABLE="width: 500"]
<tbody>[TR]
[TD]Number[/TD]
[TD]Title[/TD]
[TD]Rev[/TD]
[TD]Asset[/TD]
[TD]total amount of assets[/TD]
[/TR]
[TR]
[TD]UC02-WPD-UT-REP-N001-000012[/TD]
[TD]Network Design - N1[/TD]
[TD]P01[/TD]
[TD]WMI-4A-0056, WMI-4A-0063, WMI-4A-0063B, WMI-4A-0063A, WMI-4A-0062[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
My boss has now asked me to list out each Asset number separately, so i need 5 lines, but still with number, title, and rev info showing in each line. I have over 1000 separate assets, to do it manually would take ages. Is there a formula i can use.
Any help would be very much appreciated. SOrry if it is not explained very well
I have a spreadsheet and in the asset column i have a list of numbers related to that one line of information. All separated by a comma
[TABLE="width: 500"]
<tbody>[TR]
[TD]Number[/TD]
[TD]Title[/TD]
[TD]Rev[/TD]
[TD]Asset[/TD]
[TD]total amount of assets[/TD]
[/TR]
[TR]
[TD]UC02-WPD-UT-REP-N001-000012[/TD]
[TD]Network Design - N1[/TD]
[TD]P01[/TD]
[TD]WMI-4A-0056, WMI-4A-0063, WMI-4A-0063B, WMI-4A-0063A, WMI-4A-0062[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
My boss has now asked me to list out each Asset number separately, so i need 5 lines, but still with number, title, and rev info showing in each line. I have over 1000 separate assets, to do it manually would take ages. Is there a formula i can use.
Any help would be very much appreciated. SOrry if it is not explained very well