Link to home
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Macro or formula to split data in cells

Hi Experts

I have the following data extract in column A2 onwards

All | company name | green | all | sla | all |

And I want to paste into cells b2 across each of the names as above so we have:-

B2.                         C2.         D2
Company name   green     all

Etc
SOLUTION
Avatar of helpfinder
helpfinder
Flag of Slovakia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of Bradley Fox
Bradley Fox
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This is how the result should look like
sample.xlsx
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of route217

ASKER

Excellent feedback