How to convert a group row header into column cell value?Get content of a cell given the row and column numbersCheck if Cell value exists in Column, and then get the value of the NEXT CellShow the column header to a row if there is value in cells of that columns without VBAhow to get excel column index by searching with cell text?How to read single Excel cell valueHow to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loopsIndex column header based on value in row Excelcell value shift in row grouping excel JavaCopy columns by its header valueHow to sum all cells based on each cell's row header (duplicated) and column header (duplicated) in Excel/Googlesheet?
Why does lemon juice reduce the "fish" odor of sea food — specifically fish?
The meaning of the Middle English word “king”
Fixed width with p doesn't work
Does "Software Updater" only update software installed using apt, or also software installed using snap?
Grep value of a specific key from a String, concatenated of key : value pairs
Problem in downloading videos using youtube-dl from unsupported sites
Biology of a Firestarter
Extract vertices QGIS 3
Formal Definition of Dot Product
Find the unknown area, x
Could there be a material that inverts the colours seen through it?
Wireless headphones interfere with Wi-Fi signal on laptop
Will casting a card from the graveyard with Flashback add a quest counter on Pyromancer Ascension?
Why is it harder to turn a motor/generator with shorted terminals?
Why doesn't Iron Man's action affect this person in Endgame?
Is it wrong to omit object pronouns in these sentences?
Why weren't the bells paid heed to in S8E5?
How might a landlocked lake become a complete ecosystem?
As programmers say: Strive to be lazy
Under what charges was this character executed in Game of Thrones, The Bells?
complicated arrows in flowcharts
Mark command as obsolete
What information exactly does an instruction cache store?
How to redirect stdout to a file, and stdout+stderr to another one?
How to convert a group row header into column cell value?
Get content of a cell given the row and column numbersCheck if Cell value exists in Column, and then get the value of the NEXT CellShow the column header to a row if there is value in cells of that columns without VBAhow to get excel column index by searching with cell text?How to read single Excel cell valueHow to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loopsIndex column header based on value in row Excelcell value shift in row grouping excel JavaCopy columns by its header valueHow to sum all cells based on each cell's row header (duplicated) and column header (duplicated) in Excel/Googlesheet?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have data that is grouped as shown in image1
I want convert the grouped rows headers into column cell values as shown in image2
Any way to do it in Excel, or in R?
Before:
After:
excel
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
add a comment |
I have data that is grouped as shown in image1
I want convert the grouped rows headers into column cell values as shown in image2
Any way to do it in Excel, or in R?
Before:
After:
excel
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
R and Excel are very different tools. You should tell us which one you are really using here.
– Tim Biegeleisen
Mar 23 at 14:03
I am hoping to get it done in Excel but if thats complex, R would be fine assuming its not too much R code..
– Vijay Agrawal
Mar 23 at 14:15
Please share sample data usingdputand the expected output
– Sonny
Mar 23 at 14:16
add a comment |
I have data that is grouped as shown in image1
I want convert the grouped rows headers into column cell values as shown in image2
Any way to do it in Excel, or in R?
Before:
After:
excel
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
I have data that is grouped as shown in image1
I want convert the grouped rows headers into column cell values as shown in image2
Any way to do it in Excel, or in R?
Before:
After:
excel
excel
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
edited Mar 23 at 14:49
Vijay Agrawal
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
asked Mar 23 at 13:57
Vijay AgrawalVijay Agrawal
2,91011520
2,91011520
R and Excel are very different tools. You should tell us which one you are really using here.
– Tim Biegeleisen
Mar 23 at 14:03
I am hoping to get it done in Excel but if thats complex, R would be fine assuming its not too much R code..
– Vijay Agrawal
Mar 23 at 14:15
Please share sample data usingdputand the expected output
– Sonny
Mar 23 at 14:16
add a comment |
R and Excel are very different tools. You should tell us which one you are really using here.
– Tim Biegeleisen
Mar 23 at 14:03
I am hoping to get it done in Excel but if thats complex, R would be fine assuming its not too much R code..
– Vijay Agrawal
Mar 23 at 14:15
Please share sample data usingdputand the expected output
– Sonny
Mar 23 at 14:16
R and Excel are very different tools. You should tell us which one you are really using here.
– Tim Biegeleisen
Mar 23 at 14:03
R and Excel are very different tools. You should tell us which one you are really using here.
– Tim Biegeleisen
Mar 23 at 14:03
I am hoping to get it done in Excel but if thats complex, R would be fine assuming its not too much R code..
– Vijay Agrawal
Mar 23 at 14:15
I am hoping to get it done in Excel but if thats complex, R would be fine assuming its not too much R code..
– Vijay Agrawal
Mar 23 at 14:15
Please share sample data using
dput and the expected output– Sonny
Mar 23 at 14:16
Please share sample data using
dput and the expected output– Sonny
Mar 23 at 14:16
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55314445%2fhow-to-convert-a-group-row-header-into-column-cell-value%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55314445%2fhow-to-convert-a-group-row-header-into-column-cell-value%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
R and Excel are very different tools. You should tell us which one you are really using here.
– Tim Biegeleisen
Mar 23 at 14:03
I am hoping to get it done in Excel but if thats complex, R would be fine assuming its not too much R code..
– Vijay Agrawal
Mar 23 at 14:15
Please share sample data using
dputand the expected output– Sonny
Mar 23 at 14:16