Working on a data science project makes you play with diverse data sources in the most crazy way you can imagine.
While aligning the data programmatically via data frames in the most sane way to do, but sometime you just want to check the data in a quick dirty way via the all familiar Excel.
Aligning the data in one format (vertically or horizontally) can be a challenge though, since there is no universal rule for defining what should be on X axis and what should be on Y. There is one trick though you can use to quickly transpose the numbers either way (vertical to horizontal or vice versa)
1. Copy the data, say which is present in the horizontal format.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA3IAAACgCAIAAADGq8kPAAAgAElEQVR4nO2d63cT5aL/5/9wHWG/8c0+vGMtF1nrHI6K54Xnd7bZZy1dekAK/iCswt5YUwV1t0VQgaL9EUF2N7Cp3AvYFtrQNIhF2qaR0hu9WMFYLFhaS1trL5Q2bZjfiyeZzDWZTGbmmUm+nzULkidz+c7tmU+fuTGskEkrUVxc/EyM4uLiycnJZ555pqOjQ/TB7XaTfkiJUiEpFxWuXLmS61k05snJyY6ODtI/vwcrU8SDX97d3U0rkhWQXXfSjUH2M1n1ZPMDfLCxpcNrr71WV1fHfa2rq3vttdcm5ao42VpIdltN8IEbyTPPPCMaahJbu65Ydr/gr/Hjx49zX8lnpQ1M5TE38QZmNSy7jjIDxspaqQYrb7sAAKAXx48fX7lyJe0UAACQCGglAABYF65lCHUdAMD62F4rAQAAAACAFYBWAgAAAAAAHRBr5fcAAAAAAACkjlgrhwAAAAAAAEgdaCUAAAAAANABaCUAAAAAANABaCUAAAAAANABaCUAAAAAANABaCUAAAAAANABaCUAAAAAANABaCUAAAAAANABaCUAAAAAANABaCUAAAAAANCBJFoZBCli3KqiPWeZAxYpAAAAYATJtTICVBM0WCtpz18mEBRqJe04AAAAQOYArdQTaKX1gVYCAAAABgGt1BNopfWBVgIAAAAGAa3UE2il9YFWAgAAAAYBrdQTaKX1gVYCAAAABgGt1BNopZk8fPiwv78/1aGglQAAAIBBQCv1BFppGgcOHCgoKCgsLDxy5EhKA0IrAQAAAIOAVupJSlrp9Xq9Xq/uWhkOh+/fv3/79u3ffvttcXFR+uv8/LwBsy7D3NzcwMCAhgbFpNTU1Gzfvn18fNzj8Zw8eTKlYaGVAAAAgEGkpZWBPatWrVq1JyAovFe+aVUM0U8ZjxW0cnZ2tqenJxgM3rhxY2BggJPIcDg8Ojp67969qakpI5dBlIWFhTt37rS2tj58+FD3kX/44Yf79u3TNqwGrZTfpHmlSQoFxZvK72kLDgAAAFiddLQysGfVpj17NomPn7Hj5r3yTRkjlh/t3ivtpL1Z5CT41NTUjz/+SJ53/8MPP8zMzExMTHz//fe9vb0PHz5cWFjQddnIsLCw0NXV1dra2tHRMT4+ruOYv/jii+0xPvjgAw1jSFkr5TfpwB7OEOMfZQsj98o3QSYBAABkA2loZWDPqk3l9+6Vb1Jyx8w6nCZ1yohltDISiSwsLAwPD3d1dQWDwVu3bnV2dv7000+PHj3SaWEkIhwOd3Z2tra2tre3//LLL7qPv6qqavv27VeuXNE2eFonwblNOrCH9ydTbB+QLYzuJ9rCAgAAAHZCu1bGjpbK8ig4ymYCiZ0yYo2T4Hx++eUX0mbZ1tY2Ozub3tzLMD09/euvv/KbP8PhcEdHR2tr661btwYHB3WfYiQSOXDgwPbt28nsjI6OhkIh8uHnn39WM3haWhnbpIUbffSbbCH5f5PsqXEAAAAgs9CqlbxDqIJXZlZbZYwEThmxklYuLi4+ePDg5s2bbW1t5FLL/v5+3U9/kzPdvb29ZMxzc3M//PBDa2trV1fXwMCAvtPiKCws3LVrVyQS8Xg8O3fu9Pv9V69eLS4uLi0tVTN4GloZ36RFG3e84V5SyD8bnlHXhQAAAAASNGql4AgqJ5D8g2n2YJGT4IuLi/fv3w8Gg62trRMTE+FwmFxqOTw8rO/8tre3t7a2tra23rlz59GjR7dv3ybnvoeGhvSdEMfDhw+3b9/+j3/8IxKJDA8Pl5eXb9++nVimSjRrpdgPVbZWSs6MZ99uAQAAIFvQppX8W2NlbnCl6JSLi4uLi4sLlAgEAoOGEQgE1GQIh8MPHjwIBAI3btwYGxsjhXNzc319fTdu3JiYmNBxfqenp2/evNnS0tLS0tLW1tbS0tLR0fHgwQMdJyHC5/Nt27bN7/eTr6Wlpdu2bTtx4sTo6KjKMfDXkcpFurCw0Lj7hRdcZ38WfN/dGP3y81nXC7sbFQp/PuuKDyn4YiZkv6CxRwIAAMgiNGmlRBt5J/fulW+i45ScUM7Pz8/Nzc3NzT02nYaGhnuquXjx4sWLF9X339DQoCbD0NBQU1NTY2Pj4OAgv3x6erqzs7O7u3t6elrHWZ6YmLhx40YwRmdn56NHj3Qcv4gvvvjigw8+ePz48e7du0tKShoaGnbt2vX+++/v2rVL5Rj460jdIv3p1Mbnn9946idB4bcfP//8x9+KPsoW/nRqY2zobz+WjshoyL4wPz8PuQQAAGA0WrRS7lacWBl5lCUfsy4lW1xcDIfDc3Nzs7OzMzMzU1NTk6ZTX18fUs1XX3311Vdfqe+/vr5eTYa7d+/euHHj9u3b0p9GR0dv3br1yy+/6D3fk21tbQ0NDaQhUPeRE/Lz85ubm99///3KysrJycn79+9rGw9/HalapFd3Pidi59XJycnJvi/fjH5/88u+WM9JCqODmsnU1NTMzMzs7Ozc3Fw4HIZWAgAAMI7MecvOwsLC3NzczMzM+Ph4EADAY3R0dGpqam5ubsH4p5YCAADIWjJNK6empkZHR4PBIAsAYFmWZYPB4MjIyOTk5OPHj6GVAAAAjCOjtPLx48eTk5MjIyPQSgA4oJUAAADMAVoJQIYDrQQAAGAOma+VzUAnzHUhoBvQSgAAAOaQFVpp7kFcT6zjcxaJATQArQQAAGAO0EpLA60E6QOtBAAAYA7JtdIuBAKBhoaG+vp6n88XhFbqjUViAA0Eg0Gfz1dfX0+eLUp7TwUAAJCxJNFKGzE4OHjv3r1QKNTb2xuEVuqNhhjhhUUjkmQb7lSQHUMwGOzt7Q2FQvfu3RscHKS9pwIAAMhYoJWWxr5aeXf49//7/66O/j6rYVrhhcVt/2x6qbCadO+VBVQOOD09nZOTMz09rWGilkVWFtUXstBKAAAAZpGFWnn/3KbYiyU3nbsvfyhv3kt+u39uU7SnWIkS8T71RKyVzXvFoaUlxpCSVk5Mz60r+fqlwurcg9emZ+c1TG5iem7tp1dSGoPX683Nzc3JycnJycnNzR0ZGdEwXQsCrQQAAGAXskwr75/btGrV3ub413PysiSVyGRaaQw8rSTR9/JiSEuMTaKyT81tjSJ+GppQ397p9XpzcnKuXbtGWiu9Xm9LS4u26coSCARWr17tdDrdbncoFOLKi4uLDx06pOOEpOAkOAAAALuQVVp5/9wmnlMmwoJaqRTDpGCJtbKnp4c0E+rbRqj+6sz8/Pz8/HyDToJPTU2tXr26oqKCZdmioiLO3vx+v5LJJWBgYKCxsXFgYEBl/+onAa0EAABAl2zSSmWrbN4bOy0e/Z1zNeGH5uj585jHNe9dtWnvXtIAaoje2UUry8rK8vPzc3JyvF6v4VHkyM/Pz83NNUgr/X6/0+mcmprif56amnK5XJ2dnSmNanBwcPPmzbm5uZs3bx4cHFQzCLQSAACAXcgyrUwiYAo2Gf0Q00nBBZcCxdSmd38VIghkrlYmTpJgwPz8/PPnzxcXFxcVFWmbNDHC3NxcbYOTk+DFxcXqtTLBzIoQaeXq1atZlj106JCG099XrlzJjVFXV6dmEE4WXyqslu2BK4dWAgAAoEuWaaXSOfB4c2UCrYzbW/NeMiJ+YVp6pyQ35rdWJkiiNEhLS0tOTk5PTw9xu7t372qYLnfDjeZrIq9du0bGcPDgQZXn4tU4JcuyoVDI6XRyJ8GLi4sDgYDL5dIQcmRkZN++fUQrAwFVV50SWeSuVVXqWGglAAAA2mSTVip5ZbyYa89MrJXcALppJcuysnJD5SS4UhKl/g8ePJifn8+y7MjISE5Ozvnz5zVMtKioqKysrKio6ODBgxoGJ3BNnur1NKlTEkgjpdPpLCoqGh4edrlcgUDg0KFDTqfT6XSm2my5a9euzZs3j42NqekZrZUAAADsQlZpZbRVUnwnOCdmMo8TEpwEj+pbXEP11EpZrH9t5fT0dG5ubllZGflaXFxMFDMl7t69S0SQtHdqvjiSaOXIyEhubq6GGCohp78rKipWr149PDzc2dnpdDr9fr/Kwe/evbtt27ZLly6p7B/XVgIAALALBmql3+/vNpFbt261t7ffuHGjsbEx0XMreY+t5HviqlWrVm3auzdha+XevZsEN/aYqpX83CS5tMRAlLSSiKCIVE9kkzPgbMwvr127pi0kd8tOShdZpkRnZ6fL5ZqamiJnw0mhy+U6ceKEmsG7u7s//fRT/iOKkqKLVjY2Nt64caO9vf3WrVsqdyiT91/dQX66ID9dkJ8uGZDfilpZV1dn5lJQq5W2wvpv2SkqKuLfZ0POg6d6IpvcRc7B6Zp6zp8/f+3aNaKVPT09ubm56ZxMTwA5/c2yrNvt1qCVGtDluZUatNLk/Vd3kJ8uyE8X5KdLBuS3olb6fD4zlwK00lBkY5DGRe4MOIGIpvqWQvLMS66BkzR/pvr8S36jaW5urkHPOTpx4gSnkidOnCDNluQkuMr7bzSgy1t2NGilyfuv7iA/XZCfLshPlwzID62EVhqLbIzz589Lz1kTw1MvdmVlZfwT1kRVtXmhoe8E505/cyVFRUXklh1yk7hBQCu1gfx0QX66ID9dMiC/VbSyp6eH+1xbW2vmUoBWGopFYiTGUK2kBa2T4Cbvv7qD/HRBfrogP10yIL8ltLKnp+fy5cvc18uXLxs620d3r3hq9ynuK7TSUCwSA2hAm1Yauf+eWvfGiqdi3cojXxsxDUPrn6O74/mfcu8z4ioqY/KfWvfGqzuuJy7RByOX/9c73GTh5x01bBpGH7+MW/IEw/ILY1fmPWW/7cfYJU8wIP+pdW8InCeOAWuB73LUtJI4pXlaeX3fSnfeOne8WoFWGopFYgANWFIr7VitE06tE6rw0d2GyA20MiGGb0LQSgV4sSvzjDN71D8STq1749WVbmnyr3e4ZcvTgr5Wck7Jj+L1evWcSyF1R15deeRr8i8pgVYaikViAA1o00oj918zqnWD8h/dbVTzqghj8punlYbW/yZsQgbn7zZ6FgzLH4ttpFN2o/6R4dS6N15dt/tVUYNl3ZFXVx7Zp/sceb1emlrJd0q+VtbU1Og5lwK+3kHc/Pq+lbEzUNBKQ7FIDKABbVpp5P5rRrVuTH4zkhPMym/UHBm5/XSbsCIMzt9t9CwYlv/Uujde3VG5b6WRTtmN+kcGElsUXrZQB2pqaqhppcgp+VpZXV2t51zyidtkzC8TaiXQBXNdCOiGNq00cP8VXlu5rtKQaRiS/zr/aMpd4WfIIcqY5S9Y8rHORvk5DDcDg/N3Gz0LhuWPbkJGt9kbXP8YrpUG5I/GrjsSb7CMfdZ/jqqrq+lopdQpzdFK/rlv7rOSVgKQ5VhSK+1YrXd3d59aJ26kMWpeDMtvUmsltDIZ9tVK0jxm1B+EBNQ/ErjYCT7oBh2tlHVKvlZeunRJz7mMI/2DO+8otBIABbRppWH7b7c51box+b/e4Ra10xg1L8bkN08rjdx+uk3YhAzO3y33J4qeGHn8jV2BZqRZov6REI9NGil5zZb6z9GlS5fM1kolp+Rr5cWLF/WcS47KPOETPb7e4V6xrhJaCYA82rTSqP23u9ucat2o/OKjqVHzYkx+87TSyO2n24RNyOD83XVHXjXo0VQEw/Lzlvz1fSsNWwuofyTwY5PGNf5Xnefo4sWLpmplAqc0QSuld2ISZ4dWAiALtFJvzHjuJrRSGTOeW2lc/rojrxodvtscrewm94Mbsgtg/5UgWPL8Kyxtr5WJnZKvlVVVVXrOZTKyUytLS0vJ61VKS0tpZwEWRZtWmrz/6g7y0wX56YL8dMmA/CZpZVKn5GtlZaWRF/RKyE6tzM/P//XXX7u7u7du3To6Oko7TsqQ9w2q+dcghoeH33333XfffTcUCqkfirwKXOmrNhYWFg4fPmzEzGrTSpP3X91BfrogP12Qny4ZkN8krUwJaKUJvP/++2NjYx9//PFbb7314YcfjoyMGDet/Pz8nJwcr9dr3CQMYvT32ZcKq18qrA4vLIp+2rlzZ2dn5/Dw8OrVq1WOjTNI8kH0VRucUyZ4tbdmoJV2BPnpgvx0QX66WFQrKyoqzFwKKWmlk4fL5Tp16lQ4HNZwwHYKUTOIWzVqxrZ9+/bdu3f39/e73e7+/n7jzLKlpSUnJycnJyc/P1/H0UpnU01JSkzPzis5JcuynE2arJWcR+7bt49l2ZqaGm69f/bZZ+rHowZtWmny/qs7yE8X5KcL8tMlA/JbUSv/kP+fpnbuF5fmrVqy9YWnNz+nUitDoZDf73/99dedTue5c+e0HbMLCgqcTufw8LC2wdNhbGzsL3/5y+Dg4OPHj4l79ff3F+34cP3eix+evtEe0tMvDx48mJOTU1RUlJOT09PTo+OYjYY4pajjfqWllWVlZZxHfvnll5OTk59//jlxypmZGfXjUUMwGHx683NLtr6wNG/VH9wvmr1jokOHDh06u3Wa3U+slX19fT09PV1dXR0dHW1tbS0tLd99910gEGhsbLx+/Xp9ff3Vq1f9fr/P5/N6vdXV1VVVVRUVFRcuXCgvLz9z5szJkyePHz9+7Nixo0ePHj582NSlkLpWks/FxcVOp/PLL7/UcMCem5t75ZVXNmzYoGHYNBkbG9u9e/fg4CD5+sEHH5AP/f39b2/74E8flL9UWF3+7W29Jpebm5ufn3/t2rWcnJzz58/rNVoTWivHpx4TlZybX5D+umXLFvInwZtvvqlyhGlq5fzv9yLhR3V1dfyW6QMHDkxOTp4/f153p2ShlejQoUOHLsXusFYMbK08fPiw7gfIBEQikfn5+enp6dHRUfWtldeuXXvllVe2bt3622+/aZjo999/73Q6S0pKUh0wzdPfIqcU8W1Dk2vL2/+noOK1PT7pr38VoiYtsUmv1zs9PU38MukgGqaiAZVTkb22csuWLSzLDg8Pv/nmm1u2bLl9O7mC8w1Swy0787/f++3W8YeNu8Za/774eEJklmVlZUnHoI1gMDg6Ojo9PT0/Px+JRFQO1dvba1Aec0B+uiA/XZCfLnbPnw5ZrZWEP//5z/v379d2G/WFCxecTqff79cUWTs7duzo6OiQ/WlwcLCwqOh/3it7qbD6f3Zdlu0nVdsrLi7Oycm5e/cuGzsb3tLSknQoNVNJ/05wo81VF6Z+vPywcRe/G/2uJDw5KG2zNGLq0Eo7gvx0QX66IL99yWqtZFl2eHh4z549Tqdz27ZtGiZaVFTkdDofPHigJXEajI6O7t27d2hoSFQ+ODi4Y8eOH378iTTOfVJ+U2kM6j1sZGSEf6cOablU2bRmju2lNBXRE4W0PWBIRNLWyieRyERvucgsHzZ98vjh93yz1P1mHQK00o4gP12Qny7Ib1+yXStZlu3q6nI6na+//nqqU1xcXHzllVfUX5NHSHoDuMpT4WNjY3v37uXfKjQ4OFhUVDQwMEDufX71E9/IxKNUZ0qK1+vNkZCbm5v+mFlTrq0UIXqikPoHDIUXFomsj/4+yy9XeW1lZDE83nFUbJaNu2buNRGzNOJmHQK00o4gP12Qny7Ib1+yWiv9fr/f73/nnXecTuenn36a6hR/+OEHbRdW6gUxy19//ZVl2QcPHuzYsWNgYIBl2enZ+Zd3ervu6vN0dHL3NzkDTigrK8vJybl27Zou4zcZ0a3fKd0Jzpnl9Ow8V6j+lp3F+ZmxmwelZjl5+9KTiMztRHoBrbQjyE8X5KcL8tuXrNZKwoYNGw4fPpxqQ5GGJ1YawdjY2J49ezo6OjinZFn20Vz42q37uoz/7t270mdVkmdYFhcXpz9+81srNWhl4kcUpXQn+MKjsdHgpyKtnP75W61zowpopR1JJ7/PxTAumdv1zCSbl79ZhDwOxfVsYv5EMTRj4eWvan4tmd+QNSUlda1s3rmcWb6zWb1WhjwOQR1nUJWXklZSJ43T30yKnSYYJrXOPoieKJTSA4bm5heIU45PPeYKU33AUHhy8GHTJ6Y5JaunVoY8DoaR7r4+F8MwjMOj/epUA1Cq1k2qWdMmnfwW10qyvZgTUPPqls9PojNp5ddvC9SkldGdOErivVZdVPO0UlrT0NidNWulcNFT2EetqJWn1zAMs3x5ilpJtoXYlhDyOIw5/thLK9Mgo7RSl8tMVSJ6otC9e/dYlu3p6SFfkz7jXXptpdLzhpIyN3p7xCynZPXWSodDvAf7XIzL5YJW6kvmaqXPxThcLpPWgp5aKWgh8bm0bvA0tdLnEthMyONIaJYW1EqHwyGeA1tpZXxp+1ym/zFuRa3k5DJFreRVc8L6ji/vvJnlFcf3Ycbh8bgSKD600o5ambU8+iVojlOyemuly+cTKKS0TLL/Svd6EypTFVomrGTjs8DNkrRBR6HKslb+RPWtaYcxRa0kOcUHOMV54TcQxpa6Ys+81ROdhspmOVX5FZef7FYR8jgcnpBoK5KNpGZwly/em2BPU9pQk2sNt/S4iQr23JSiprS/JD+ayy//6JA+vt0LNwWZySnvAoYsdm6cqpa/IJx6HTI2eaprSopJWhmdHams85dT9Jf4X4GCwmQzBq2EVgJZ9NZKVuyQgiK5/VdhVzeUNLWS4Vc9vL9uTZsPXbSSypInKOWPxRSlUZoXsewn6lmuLUbXk+CCDYM/R3LLWNAzv6FTFCnh4OQHwcUnaibhc8lpjfwGwC0+/lnF6F4sI20CteHHk48hf4hXoSnKWhkSLwLecpWJlyCEAYudG6c6rU+6p8qsFKOTp7qmpJilldzfnAI15y9hn8xZtPgmk/ysTtZoJQCpobtWCivDWFUnPWDJ7b+mnbRKu7VSUq6mytIPfbSSxpInyOcXHeLiy0+FKapaQeJZ1FUro1OTtN/JbhVSe5RLr25wwRfFVSowdgWtlC6L2OjkjrHKIVTMqeKsqbpGI5FW8mwrPm3FeMLllWRfTnexc+NMTSuV8kgXlfHJU11TUszTSvEcCZrYBTuq8BdoJQBpob9W8g9FXP0jd25J0kJjntsYo5XyVZbF8kvaHsxd8gTZ/ILjl+RL4tZK3kwpzji3jhTGm25+wYzED8myW4Vio6Tk+J98cNWWwK3q1FsrEzfssNKDMPdjohhys6aDVnJiqdz0JP1F3LJpxGLnSF0r5fJIV4rxyVNdU1LoaqVcYLkaEVoJgGYM0MroJ5mjv/z+G/tsotsYo5XmiZleWmn+kieouROWETb6JVN5hXYzGR/SoY022QNikuq6+tbK5IOn3vjkkssvdxjlygxprZSdNV20MjoaT/LWSrldwLDFzhWndm2lGh0yK3nCyauCnlYq/OkkPn8DrQQgPYzQytjxPrZTymklb/+ND2Ca2yQ6iclLzatvmSRaqVRlGUMa+UXVpdlLniCTn3+dWDwZb2uRzovPleRoK5xx/ojjv2taZ9L8IY9D6DTy51MFMye36QgHSDS4GkuQm0TI45BtLeM1ssp8l7mMTxpVIGZKV+wl2V900krxhq0UL/bNIb5O1IjFzo0zuVYKFn6iZSVcKYYnF03daK1s3rmc/3dmErlMppVsfLMQ/t0au3iFcXg8sUoFWgmARgzRSmElLm4qE++/3ADmuY0kP5dL1KQRK0zaWhn7SVplWSy/uLo0eckTpNtPwrYyNtG8yCxwuZ75vUr+nEl1XSVrbeWPT3ar4Br0JWtNHCnB4Lwh5C0hemO0ZMOQvRNcuOSkSyUeRBxNZm0IdgrFGHKzppdWSrds2XhyPSpmS3exc6UqWusTnt6WXNchW2RE8lTXlJQsfcsOANmDVd6yo7GO0ogl33KRAnrmN3fJE3TJL2pFkbv8zyjSzm/6ZQdCsP3Txe750wFaCUCGYxGtNNlt7F6t65ifhlXqk196Nh9aqRJs/3Sxe/50yCitDIfDMzMz4+PjQQAAj/Hx8ZmZmXA4TE8rzXYbu1fr+uWnYpV65RecmzPNKVloJW2Q374YpZV/yP9Pk7ulb7+4NG/Vkq0vLNny3NO5//H0ppX/4vr3f9n4b+jQZW/n+venN618Ovc/lmx5bsnWF5bmrVr69ovm75vo0KFDh852nT5aeeXKFb/fX1dXV1dX5/P5fD5fbW1tbW3t5cuXvV6v1+utqampqamprq6urq6+dOnSpUuXLl68WFVVVVVVVVlZWVlZWVFRUVFRQWERuF9c+vaLS99atWTrC0v+8vySLc89vRkdumzvlmx5bslfnl+y9YWlb61a+vaLf3BDK9GhQ4cOXfKuVxNirezWCZJJm+pq48mTJ4uLi+FweG5ubnZ2dmZmZhqArGdmZmZ2dnZubi4cDi8uLj558sTMvRIAAIDtSEfhMkornzx5EolEFhYWwuFwOByeT48TJ0402Bnkp4tF8jc2NjY2NjY1NQUCgebm5ubmZpWXY545c8bQyz2NBvnpgvx0QX662Do/C63kw8ll+pw+fTpgZ5CfLpbKn5JQEmxdLQaRnzbITxfkp4ut87PQSoOw9WYRtPlmHUR+2iA/XZCfLshPF+SnCAutNAhbbxZBm2/WQeSnDfLTBfnpgvx0QX6KsNBKg7D1ZhG0+WYdRH7aID9dkJ8uyE8X5KcIa6ZWHt294qk3SPfqjutW0Ur+A3PFbyBWUygojj9wl/pmcSFvGcMwy/IuJCkseTkWXlCM/GmSeflJCeHlEpnSeKGN8iusKbvkV1j8tslPIDsBv2fkTxN1+fllgrmyR/545Sn+BfnTJJ38rHlaWZm38sjX3Oen3sg7agWtDHkcMRUMeRwxXfS5BG9LJx9lCxXfCEZ1syh5mWGW5ZXkLeNvFnKFpOwC9zleryB/GmRi/gt5y2JfLuQti0XlzQB/XmyWX7SmgkEb5ZfffOySP9b7spdfXmYdLcue/BfylokVmWCT/JLBYsXInwbp5mcpnQQ/tc4iWsmHM0TB68piL9GSLWR9LoVXglH/a4OsfdHBUlR4Qew4FtECAvLTRTa/8E+uKacAABGQSURBVBeBywgOUfbIr9ynrfLLlNknP9lsxD0jf9qoyW9NrSSktv2LCpE/bbTnZ+loZWXeU+59dVbTypg4Chsgo99kC8n/DrlT41bdLCQmE69VBF+QP20yMn8wGIwnFfYh+GaL/An6tFX+oLit2D75Y15jKy3LnPz8E5vWuggnxe3fUq31hOzNz9LQylPrrHRtZYyQx8E49v/45MmTO/sdjGP/ndgTKGs3Mo79d2QLI7UbGa70zn4Hw2ystc5zK8+/tYxZ9tb5xIWf/SlerSxbxvzps2g58qdN8vzNzc2fvSzIbwetFLZ1CE/z20ErpeX20krpXyYyl/vZI3+8scxGWpZB+UWlVrkIh5BSfrHpIH/aaM/Pmq6Vp9a9sWJdZZKezNfKWlfUDxcWFn4oWcGsKOmLvi6nj3zrkyucr9nAMBtqRIVWecvO2b/+K/Ovfz2ropCw778Z5r/3Rb8gf9okyi/39hp7tFbym8Xs2FopbtZT6NNW+WN920ELePn5Z2Bto2UZlF/mF3vVPwl6Rf600Z6fNVcrk7dTUtFKn4thHPtvc+8Ev/Qmw7xZGX0rclfxs8z6yunpyvUMs15c2FX8LPNscVe8kPty7Nixesqc3PJH5o9bTqoorK+vr6/f/V8M81+7Y9+QP22S5P/2228bGhoaGxuJWVrplh2CTLUirlPsdm2lwjHVNlqp7AT2uDZLmF/mPlLuV+RPm4zffgTFopOyyJ822vOzJmqlWqc0VytDHgfDODx3IpFwODw7OzsxMWH8CgMgGAwG/X5/fX19Y2NjIPCZ5a+Nu5C3TFqn8CoUq2uxbH7ZPoNBu+S/kLdM8KgYmy5/ac/Inz7J88efIyAxBlvk5/0gvtQP+dNGe37WNK3kPbSSdNa4E9znEv+5mXOeLBcADCUYDPqObfqj7AXzFnjAhLgJRto0I77o3zqX/KvPL9ennfJb85aLVLafKJbSsqzJzy+00EnYlJa/fAsa8qdBuvlZvGWHEIlE5ufnp6enR0dHg9BKYDzBYNDn89XX1zc0NAQCAdGebYG/VtMC+emC/HRBfrogP0VYaCUBWglMJgittDDITxfkpwvy08Wm+XU5MkIrAdBIEFppYZCfLshPF+Sni03zs7F2Sq7TcGSEVgKgkWAwODo6Oj09PT8/H4lEaMcBAAAA0kJ/rbxy5Yrf76+rq6urq/P5fD6fr7a2tra29vLly16v1+v11tTU1NTUVFdXV1dXX7p06dKlSxcvXqyqqqqqqqqsrKysrKyoqKioqBAlM6Nzv7g0b9WSrS88vfm5BFo5MDDwzTffSMu/+eabgYEBDUsQZC3BYPDpzc8t2frC0rxVf3C/SGGbR4cOHTp06HTqWIlW9qaOWCuHdILCElGnlS0tLfn5+T/++CO/MBQK5efnt7S0GCEfIFOBVqJDhw4duozpWCNaK/XSyqGhocOHD+tw6FaNypPg/f39bre7sLBwYmKClExMTBQWFrrd7v7+frPCgkwg8Unw3t5eKqn0Avnpgvx0QX66ID8toJVx1F9beeDAAbfb/fnnny8sLCwsLHz++edut/vAgQNapzxUU7A2SkHNkNaxANsBrbQyyE8X5KcL8tMlm/Nno1YODw+/9957brf7q6+++uqrr9xu93vvvTc8PKxlqkM1BWvXlrbHv9a0K/XaXgrrzCyglVYG+emC/HRBfrpkc/5s1EqWZdva2tw82traNE1zqKaA55RJgFZmGtBKK4P8dEF+uiA/XbI5f5ZqJcuy586dI0559uxZjZNUtEq+QZLP7aWx8+TqPRRYHGillUF+uiA/XZCfLtmcPyWtbN65nHud5JrTltHKkMfBxVpfqUorZ2ZmPvroI6KVH3300czMjJYJD9UUyLc/SrWSRWtl5hEMBkfPrRW/aJVx+ViWtUC1QvYLhyckKhGkZFnW5+IK+T3bMD+/X4vnj8dXKLVNfvmVYsv8/PjIny5qt3+WZWM7sX3qH+RPRApa2bxzzc5mnmAu575R1cqQx+HwhFg2Eon0laxgmPXnVGjlkSNH3G733/72N3IPuMaoKbRWstDKzEPaWulzxXdYqtWKz8UwDo/P4+DVFLE9hY3WLySoz8XwS+O92yM/6THEDRSvLi2Xn/W5ZJLyZoA/L3bJL79Rsaxd8ssXsizyp4X6/LHvDpfLYR0tQ346J8FPr7GIVsaIRCLzfSXPMs9+clNeK8MLi8ev9q3Z5399T+26v/3dnf9OX19fX1+fO/+ddX/7++t7atfs8x+/2hdeWFQ9TSWvhFZmBWKttJCWEYSBZH8JeRzxCoanmDbJL+zDNvnjPwgqeMHKsEd+5VLb5RcVIn/aqMxPNntxz8ifNtTya9TK5p3Lk1klDa2s2ZCgtbLsyvfb/tl0+/747fvj7xxp+LS8kZR/erbhnSMNpHzbP5vKrnyfwlTbS9fK3AnO08320rXQygxFpJVWai0gKGuZqLmMcfkkPdsjv2ChC75YOH+8WVJav3PfbJFfUmyR1kpCSvnFhcifNqryx/6WslH9g/xJSE0ruYsrkzolDa28U7KCeba4S+naytf2+ManHpPP41OPX9vjS1yuFt5jKwVtlNEbdEo5m4yW4ZadTEGolbUui11bplytiMujVycKe7VLfv6loQ6Lt/ZxWWMpRX3wm1ttkT9Bz7bJrzBTyJ82KvLHG+jtuf0gvxzaWyutcm1ljNqNDLOipEv5TvDX9vhGf58ln0d/n+VrpWw5AInha+Wd/WIDsmK1wrKsuFlDcJmcZa7tI6jJL/7F0lrJ/0GmicAurZXiyyhZuZVir/zSQuRPm6T5+Vd92EHL+D8gvzJpXFuZzCvN1Eqfi2Ec+/sSPmCo7Mr3BSeC41OPx6ceF5wI/tPfm7hcX9byMGL8wHx4WlmzUVLNW7NaER3+bac1yk5po5OwvF/seW2l9JpWaX82yi9biPxpkzQ/70xD/JRDdADkTxtq+VO6E3zn6fhn67RWRhtZ7iR7bmV4YfGIr+d/99b97966I74e7tYcpXIAEsNpZV/JCobZKGo8sF61ImqOZFlWqDXC5g575I9j+WvLQh6HzJIWXeVqYS2Wz6+4UuyRX36mWBb5dUDN9qPQM/LrALX8qbRW8h9bqeLiSpO0Uirca8+peRw6AGkS08rKDQzj2H9H9Cv1B0yI/wSV7incTS/iv1Ttkz/kcciFZy2Yn59VYsvSObBHfoWNyjb5lVYK8qdFKtt/FEtpGfLjLTssy6b+lh0A0gRv2bEyyE8X5KcL8tMlm/NDKwHQCLTSyiA/XZCfLshPl2zOD60EQCPQSiuD/HRBfrogP12yOT+0EgCNQCutDPLTBfnpgvx0yeb8Yq3s6+vr6enp6urq6Ohoa2traWn57rvvAoFAY2Pj9evX6+vrr1696vf7fT6f1+utrq6uqqqqqKi4cOFCeXn5mTNnTp48efz48WPHjh09evTw4cO9JtLd3d3Z2Xnz5s2mpiZoJTCBYDDY1NR08+bNzs7O7u5uM7d2AAAAwIKgtRIAjaC10sogP12Qny7IT5dszg+tBEAj0Eorg/x0QX66ID9dsjk/tBIAjUArrQzy0wX56YL8dMnm/NBKADQCrbQyyE8X5KcL8tMlm/Nni1a6JQwMDJgZD2Qe0Eorg/x0QX66ID9dsjl/Fmml6GthYSHMEqQDtNLKID9dkJ8uyE+XbM6vRSubdy5X81Jw07SS/6rL9ZWqtFJXhmoK1kYpqBkybDLAagSDwdFzaxkx0ZciU69WyH7Bf80rb0+JvbmZFbw/1jLvtGVZLfmt805klpXLTyB54+Xyc2Wb/Arx7ZKff/QQzIFN8sf7FO0Ctslvn/qHkFH5xS8P1+f4lbpWNu9cvnz5cutoZcjjcHhCLBuJRPpKVjDM+nPKWvlSYfVLhdVciQ6nxYdqCtauLW2Pf61pT9Q7yCSkrZU+V/zIRLVa8bkYxuHxeRz8asXnin3h5fS5BEdYixyWVOcnPUrmirVi/tgvDpfLIQjNq+KtvPxjv4jyyy9+u+QPeRxCHY5hk/yivTaOTfLbqP6J/ZJR+SWD6XH8SlkrT69ZvrP59BrraGWMSCQy31fyLPPsJzdVtVbqcVp8qKaA55QgyxBrpYWqFYLSEYf3g+CoyqsibZJf2If185PFzSsXuJhgZdgjv3LfNslvTa0kqMkv2Ob52CO/zeqfjMuv3LuJWnl6DbPm9NCQVbWyZoOa1krSYCnVyr6+vtTMMoFV8k6Mx/poL11bUNMeLS+oGRIP316Kc+j2QqSVVmqtIShpmaBZzOciJz7EPdsjv2ChC75YMH/sGCS0euHpcO6bLfLzELa12iY//yS4tS6iUJU/5HEwDofcZQj2yG+r+icj83PoePxKSSujUmlVrbxTsoJ5trhL5bWVotPi/LPhaic5VFMgL4LtpZxNDtUURG2xvZS7+JIrbC/lWycaPu2FUCtrXRa7Nk6m+uCupBG2z0SLhTWNXfLzL21yWLm1L96woaSVguYOW+RnWcWNyjb5+X1b5SIKgor8fJkXzoA98rMsa5f6J3PzsywrsUqztLJ55/KYS1pRK2s3MsyKkq6Ed4InaK0U9akKpdZKSStkaTsrao3kFZI+20vRVGk3+Fp5Z794T7VctSL6gXdxYryysfpJHN4PMqcurdxayT9bZsfWSvn84r6tq2XJ89tx+5FeRGG37ccu9U+m5pfplWCOVp5eI7lliDRdWkErfS6GcezvU/2AIVYimkl1Uw4Fr0yulfE+SIunYrsnsDA8razZKNEci1Ur8r/YR2tU/GKhW3YI4sOPGIcnZJtrKxXyK/WO/DqgIr8gs5X3X/n8PtvUP5mZn3/GQcfjl7bnVlqqtTL6R8KdVJ5bKVuSuFye9tK1MneCi06Cx9ojuQcQ8b1zqKagoLQUVmlDOK3sK1nBMBtFjWcWq1ZYNuRx8P9cJdUIvz6x/kk0+aQEG1zbJ1cuvCnfulqsUK68UmyRP34fu2QDskV+xRPidslvo/pHttzu+bnvkpM/2a2VUgtfey7pW3ZYfVorWZYV3J0jbI4UFbWXri0oLS0Q3scT/QGXVdqRmFZWbmAYx/47ol+pP2BC8nep/N0J/F4to2Wq8/PKRBWo9fJzSNuIZfqySX75jYq1S36lrd8u+VnBGrDMtd0p5LdP/cORUfmlf5AT8JYdlk39neD6tFamgOKd3rhZx6bgLTtWBvnpgvx0QX66ZHN+aKXacilrFVDoXUErcVmlbYFWWhnkpwvy0wX56ZLN+bNaK5UwJqBUK8mZckilXYFWWhnkpwvy0wX56ZLN+bNXKwFIE2illUF+uiA/XZCfLtmcX6yVfX19PT09XV1dHR0dbW1tLS0t3333XSAQaGxsvH79en19/dWrV/1+v8/n83q91dXVVVVVFRUVFy5cKC8vP3PmzMmTJ48fP37s2LGjR48ePny410S6u7s7Oztv3rzZ1NQErQQmEAwGm5qabt682dnZ2d3dbebWDgAAAFgQtFYCoBG0VloZ5KcL8tMF+emSzfmhlQBoBFppZZCfLshPF+SnSzbnh1YCoBFopZVBfrogP12Qny7ZnB9amZxRACSw0Eprg/x0QX66ID9dsjk/tDI5tAUGWBEWWmltkJ8uyE8X5KdLNueHViaHtsAAK8JCK60N8tMF+emC/HTJ5vwpaeXpNfzXTCZ7K7hpWsl/K+36SrVaeejQIbfbffbs2aR90hYYYEVYTisr11vvnbAsG9sveJH4Owrv/cFWfKcwy6rPL9Mny9onv8Lit2D+eKFgY7fN9hMv5OfnrxWb57fj9qO4U9skv+D929au/+OFCvkF/ZqplWtOW621MuRxODwhlo1EIn0lKxhm/TnVWsmy7OnTp5P2SVtggBVho1p5bj3zbEnffCQSYUMeB2/PpFqt+FwM4/D4BIHYkMchPPLE+wyJPrI2yy/qk2VtlJ9fvVvlsCq/VEPSpWyn7Ucuf+zwEf2VtwLskd/224/sTsGytsnvcwn+vrLb9s/fZ4UbUDr5/z+UMSK+M0e6nQAAAABJRU5ErkJggg==)
2. Go the sheet now where you want to paste this in the vertical format, right click on cell where you want data to start from, right click, and from Paste options choose Transpose option.
![Paste Options menu Paste Options menu](https://support.content.office.net/en-us/media/1521e1b2-4b39-45d5-8a39-e3159651e5fc.jpg)
3. You will have the data in the format you want.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMIAAAEjCAIAAADv7En1AAAJD0lEQVR4nO3dwW3jVhhFYbWSAtSAC8jWXXgtIHUYcBPZqACX8Ffwdi7mZCFToih6TPlqQmneORggY45CUJ4PlOO5o2xYu9ba2pcQ5fUDm/wUYf42rJuM7iKvHxnlef3IKM/rR0Z5Xj8yyvP6kVGe14+M8rx+ZJTn9SOjPK8fGeV5/cgoz+tHRnleP6sz+uufv/+MH+t+GpNuw6it2uq//bf6se6ncfXu4m607jWEPfpTaH/Mi9q61xD26E9BRnfRoz8FGd1Fj/4UZHQXPfpTkNFd9OhPQUbX9fH2tBl6eZ85+s3Bs8NPbx8rPIXfkYyu6ePtafit/3h7Gni8vxxFnH46e5CPt6cRnjWewu9JRj/tKOL9ZXS7+Xh72ry8f3GQ95dZRDICOmU0QDm/wXx+NHvw8M+nuZc6GdElo5OTyevU4YYze3D86jZ+UURGQIeMph4W3o0uXumOD5ERvTEaGxo+Xva10ZkcGU3rh9HH29Pm4qvkEZnTT2cPjuicY5QRHTF6f9lMOvGYfivou4Nn30ySER0x+m09+lOQ0V306E9BRnfRoz8FGd1Fj/4UbsPofx7tTjr+Hvz7mDEwWvfTuHr3cjeqxwzvRsD9vKit7eGHISNARmHICJBRGDICZBSGjAAZhSEjQEZVtd9tN5vNdrf/5uDr8/BHaqfDyAjontHr82az3b3utmMxcwcPx/bHnz+/VpWMhjpndGh/zmjm4H5q6vMDZATIqKqWMBrfgcYfICNARlW1iNH4S6PNdruV0VkyqoWMRnk3miajupqRX2JfJKO6ktH4v9lk9FnnjEZf8Jy+IzR38PB9pMl3jWQ01DmjNGQEyCgMGQEyCkNGgIzCkBHgFjsMt9itNbfYYXg3AnxRC0NGgIzCkBEgozBkBMgoDBkBMgpDRoCMyi22jOLcYsvoZrnFTpNRucXOTyKjcoudn0RG5RY7P4mMyi12fhIZlVvs/CSdM3KLLaM7CBkBMgpDRoCMwpARIKMwZAS4xQ7DLXZrzS12GN6NAF/UwpARIKMwZATIKAwZATIKQ0aAjMKQESCjcostozi32DK6WW6x02RUbrHzk8io3GLnJ5FRucXOTyKjcoudn0RG5RY7P0nnjNxiy+gOQkaAjMKQESCjMGQEyCgMGQFuscNwi91ac4sdhncjwBe1MGQEyCgMGQEyCkNGgIzCkBEgozBkBMio5mbXoz9AO23VxkePB5ER0D2judn1frcdPtjvtoOZ0R/sj36KjIDuGR36elp0/JWzEe1+5/rxPBnVkoXafnq/+vwIGQEymrD46vj+4q8gyWicjOorRuOZo3ejXyejmmV0NpUtvzb6JhnVBaP9bnvxl7HHjpz0X9Q5o7nZ9fTYYOb0fSP/Dv+0zhmlISNARmHICJBRGDICZBSGjAC32GG4xW6tucUOw7sR4ItaGDICZBSGjAAZhSEjQEZhyAiQURgyAmRUy7fYc49ERkD3jK7dYk/eQVtGn3XO6NCCLfYXHyMjQEZVtfDdQmcfiYwAGVXVki32V0eQESCjqlqyxf7qkcgIkFFVLdpif/FIZATIqKqWbbFnHymjzzpntHyLPfsO2jL6rHNGacgIkFEYMgJkFIaMABmFISPALXYYbrFba26xw/BuBPiiFoaMABmFISNARmHICJBRGDICZBSGjAAZ1eIt9tzbYsvos84ZXbPFHg6OF5HICOie0aHlW+zpMWQEyOgCxnnTLXZNBm3ICJBRVS3dYh8XRyNXyAiQUVVds8UeHu070Z4no7pmiz19ODICZDR1MXw4NbTfbYfXMu9Gl3XOaPkWe/y9JN8Xe1rnjNKQESCjMGQEyCgMGQEyCkNGgFvsMNxit9bcYofh3QjwRS0MGQEyCkNGgIzCkBEgozBkBMgoDBkBMqpr3he7hj+Ec7Y2qXNGy7fYw8O3z89bGU3rnNGhhVvs/W67eX49O4SMABkdfXy7xT4gmjwYGQEyOgr5Zos9IJLRbDKayjg22tGeEMloNhlNZRw632JfDiI/fxUZATKqqmveF3v6YGQEdM9o+Rb7mIxm6pxRGjICZBSGjAAZhSEjQEZhyAhwix2GW+zWmlvsMLwbAb6ohSEjQEZhyAiQURgyAmQUhowAGYUhI0BG5RZbRnFusWV0s9xip8mo3GLnJ5FRucXOTyKjqYxjbrGXJ6OpjENusa9KRuUWOz9J54zcYsvoDkJGgIzCkBEgozBkBMgoDBkBbrHDcIvdWnOLHYZ3I8AXtTBkBMgoDBkBMgpDRoCMwpARIKMwZATIqJZuscfHTkeREdA9o+Vb7PHk6BQyArpndGjJFltGv0pGtWyL7f9A/VfJqBZtsSdHhxsTMgJkdITxyy32zK8cHCEjQEZVtWCL/eXDkREgo6mL4cOJodfn833/8BEyArpntHiLPT44EoaMgO4ZpSEjQEZhyAiQURgyAmQUhowAt9hhuMVurbnFDsO7EeCLWhgyAmQUhowAGYUhI0BGYcgIkFEYMgJkVAu32DPvt/b8KqOhzhld+b7Y43/t+bVkNNQ5o0ML3xd75iAyAmQ0dTFp9L7Ys8eQESCjqrpyi30mCxkBMqqqq7bYk4ciI0BGVXXNFnv6IoeMABlV1fL3xb78DzdkBHTP6Kr3xZ65QyEjoHtGacgIkFEYMgJkFIaMABmFISPALXYYbrFba26xw/BuBPiiFoaMABmFISNARmHICJBRGDICZBSGjAAZlVtsGcW5xZbRzXKLnSajcoudn0RG5RY7P4mMyi12fhIZlVvs/CQyKrfY+Uk6Z+QWW0Z3EDICZBSGjAAZhSEjQEZhyAhwix2GW+zWmlvsMLwbAb6ohSEjQEZhyAiQURgyAmQUhowAGYUhI0BG5RZbRnFusWV0s9xip8mo3GLnJ5FRucXOTyKjcoudn0RG5RY7P4mMyi12fpLOGbnFltEdhIwAGf24dT9vN0xGa3a8+OOPdT+TP+6PYvSIyejYXWyxH/EHF4zW/Uyu213cjR7xx+XFr/uZ/HHtD3hR40ZPY5VkdExGaV4/Msrz+pFRntePjPK8fmSU5/UjozyvHxnlef3IKM/rR0Z5Xj8yyvP6kVGe14+M8rx+ZJTn9QP/AayokeRTrClfAAAAAElFTkSuQmCC)
While aligning the data programmatically via data frames in the most sane way to do, but sometime you just want to check the data in a quick dirty way via the all familiar Excel.
Aligning the data in one format (vertically or horizontally) can be a challenge though, since there is no universal rule for defining what should be on X axis and what should be on Y. There is one trick though you can use to quickly transpose the numbers either way (vertical to horizontal or vice versa)
1. Copy the data, say which is present in the horizontal format.
2. Go the sheet now where you want to paste this in the vertical format, right click on cell where you want data to start from, right click, and from Paste options choose Transpose option.
![Paste Options menu Paste Options menu](https://support.content.office.net/en-us/media/1521e1b2-4b39-45d5-8a39-e3159651e5fc.jpg)
3. You will have the data in the format you want.