Need a pro excel.
Budget: $30 – $250 AUD
I have a set of data in the row in excel. With 3 different variation (P, B, T)
I would like to have them rearranged dropping down in each row.
The rules are that the in each row must not have P and B together, but T can be in both P and B.
For example, the data row is P P B B B P T P B B T P ….
First column would be : P P
Second column would be : B B B
Third column would be : P T P (T can go with either inside P or B)
Fourth column would be : B B T
Fifth column would be : P
I would like to have them rearranged dropping down in each row.
The rules are that the in each row must not have P and B together, but T can be in both P and B.
For example, the data row is P P B B B P T P B B T P ….
First column would be : P P
Second column would be : B B B
Third column would be : P T P (T can go with either inside P or B)
Fourth column would be : B B T
Fifth column would be : P