Home

Is there a way to spread out a value in a row into different rows?

%3CLINGO-SUB%20id%3D%22lingo-sub-799259%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20spread%20out%20a%20value%20in%20a%20row%20into%20different%20rows%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799259%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3ELets%20say%20i've%20this%20data%3A%3C%2FP%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fimgur.com%2Fa%2F39kZHQK%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fimgur.com%2Fa%2F39kZHQK%3C%2FA%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3ESee%20how%20the%20row%2C%20in%20years%2C%20goes%20from%202008-2018%2C%20in%20one%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%2C%20is%20this.%20Select%20a%20row%20and%20spread%20the%20years%20like%20I%20do%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fimgur.com%2Fa%2Fgtamdj8%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fimgur.com%2Fa%2Fgtamdj8%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CP%20class%3D%22FJNSiirwoPtG58aeGw2Jx%22%3EIt%20was%20manually%20changed%20from%202008-2016%20to%20this%2C%20every%20row%20has%20a%20year.%20The%20remaining%20data%20was%20copy%2Fpasted.%3C%2FP%3E%3CP%20class%3D%22FJNSiirwoPtG58aeGw2Jx%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EIs%20there%20a%20way%20to%20automate%20this%3F%20The%20thing%20is%20I've%20like%20600%20rows%20with%20values%20like%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-799259%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
gsurodz
Occasional Visitor

Lets say i've this data:

 

See how the row, in years, goes from 2008-2018, in one row.

 

What I need, is this. Select a row and spread the years like I do here.

 

https://imgur.com/a/gtamdj8

 

It was manually changed from 2008-2016 to this, every row has a year. The remaining data was copy/pasted.

 

Is there a way to automate this? The thing is I've like 600 rows with values like this.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies