Learn how to unstack data from one column to multiple columns.<br /><br />Here are the steps.<br /><br />Populate Data<br />1) Select the whole stacked dataset.<br />2) Ctrl + C<br />3) Select first cell in next column<br />4) Ctrl + V<br />5) Select first cell in column<br />6) Ctrl + - (minus)<br />7) Shift cell up<br />8) OK<br /><br />Filtering & Remove Rows<br />9) Data --- Filter<br />10) Filter first column "Sort Z to A"<br />11) Delete rows of data that is not suppose to be in the column.<br /><br /><br />excel move data from one column to multiple columns,easy data unstack excel,stack columns of data excel,<br />how to combine clustered and stacked column in excel,how to create 2 stacked columns in excel,how to combine two stacked bar charts in excel,excel stacked column not stacking,<br /><br />#excel #tips #shorts #fyp
