Hi all,
A colleague of mine provided me with a messy extract where they multiple values stuffed into one row like so:
Is there any way to separate these values out into their own row?
My head is beyond melted with this.
Cheers for any help provided.
Input:
| 400.00 21.00 138.19 401.53 727.72 891.44 |
| 329.57 |
| 1500.00 60.00 28.20 9.99 117.27 9.99 1920.00 |
| 2130 |
| 8.00 21.00 541.42 362.55 1100.00 406.41 143.92 |
| 1250.00 125.00 891.44 727.72 |
| 88.00 189.00 329.57 64.2 400.00 15.00 159.25 |
| 9.99 29.99 |
| 65.00 200.00 200.00 2581.00 21.00 8.00 2700.00 |
| 28.0 891.44 130.59 76.27 2900.00 2590.00 3050.00 238.46 126.36 |
| 200.00 2.00 329.57 9.99 120.00 12.60 486.17 |
