Busymanjohn
Member
Hi all, I have a file that shows over 13,000 lines of data, the data is to be used to work out storage space, but that is irrelevant at this point. Some of the data shows that some part numbers have an occurrence of 4, 7, 10 etc etc .... what I want to do is split these rows out ,,,, so if a part number has an occurrence of 7 I want to split that out to 7 rows and not just one row ( part number has a qty of 7 and appears as one line in the data, I want to show that as seven separate rows with a qty of 1 each ) .... make sense?