Move the content of cell based on a value

That will need VBA. You might want to ask a moderator to move the post to the VBA forum. A formula could be written that would give you the output required section but 39761ACE would appear in Level 1 AND the formula would also need to be in Levels 2 through 5 but just returning blanks. And the formula wouldn't remove the values in the number column.

for example, this in (wherever the cell is below level 1 is) =IF(RIGHT(C$1,1)*1=$A2,$B2,"") then dragged right and down will populate the values in those cells.
BUT those numbers will still remain in the Number column and unless you then copy and paste special values, if you delete the numbers by hand the output will disappear.

This code should work assuming:

Levels are in column A (A2:A?)
Numbers are in column B (B2:B?)
Headers 'Level 1' thru 'Level 5' are in C1:G1
(all of these ranges can be adjusted/expanded, of course)

This doesn't use a myriad of cut/paste, just value assignment, hence the last line of code clears the values from column B to get the output as you've shown

Please Login or Register  to view this content.

The code doesn't actually reference the headers for the Levels, it's simply adding 2 to the value in column A to put the data in the 'correct' column to the right. (e.g. value 1 + 2 = 3, with 3rd column being C; value 5 + 2 = 7, with 7th column being G)