0

Before

1 2 3 4
11111-CZ20-00995 NiceFoodsCo Installment 7789231;7652137

After

1 2 3 4
11111-CZ20-00995 NiceFoodsCo Installment 7789231
11111-CZ20-00995 NiceFoodsCo Installment 7652137

Basically I need it to remove the ';' and then move to next row with same data

Any advice would be appreciated, already tried VLookup, XLookup, Trim, Row, Substitute (and combination of all these)

Scott Craner
  • 148,073
  • 10
  • 49
  • 81
soom1usedtoknow
  • 11
  • 1
  • This is a perfect case for a simple PowerQuery solution where you'll select the last column and split it on a semi-colon where you'd split the data into new rows instead of columns. Google: *"powerquery split to rows"* – JvdV Aug 20 '21 at 13:15
  • Sadly power query does not work for some reason when I try to use it – soom1usedtoknow Aug 20 '21 at 13:20

0 Answers0